Create VCR and MCR YOY

Step 1: Create VCR and MCR YOY (choose a line clustered and column chart)

                 a. Shared axis = Occurred date/month and Day of Week, Column values = Violent Crime Rate and Major Crime Rate ( Make sure to remove periods), Line values = VCR YOY and MCR YOY, Tooltips = VCR YOY Change and MCR YOY Change





                b. Select formatting, in general X position = 743, Y position = 76, Width =537, Height = 284

                c. Legend, Color = black, font = Constantia, text size = 8





                d. Xaxis, Color = black, text size = 9, font = Constantia, title off

                e. Yaxis, Color = black, text size = 9, font = Constantia, title off, show secondary on, color = black, text size = 9, font = Constantia





                f. Data colors, VCR YOY = custom (2878BD), MCR YOY = custom (FDC543), Violent Crime Rate = custom (1E5A8E), Major Crime Rate = custom (BD890F)

                g. Data labels, Color = black, text size = 9, font = Constantia, customize series VCR, MCR off





                h. Shapes, shade area

                 i. Title, VCR and MCR YOY, Color = black, background = light gray, alignment = center, text size = 12, font = Constantia

                 j. Border = dark gray



Check out how the US has done with Violent Crime over the past


Violent Crime over Time in US Link